package com.sjgl.esdn.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Date;

@Mapper
public interface MyColumnMapper {
    Long[] selectColumnIdsByUserId(@Param("userId") Long userId);

    String selectColumnNameByColumnId(@Param("columnId") Long columnId);

    Long selectFollowNumByColumnId(@Param("columnId") Long columnId);

    Long selectArticleNumByColumnId(@Param("columnId") Long columnId);

    String selectColumnIntroByColumnId(@Param("columnId") Long columnId);

    Long[] selectFileIdsByColumnId(@Param("columnId") Long columnId);

    Date selectCreateTimeByColumnId(@Param("columnId") Long columnId);

    void updateMyColumn(@Param("columnId") Long columnId,@Param("columnName")String columnName,@Param("Intro")String Intro);

    void removeBlog(@Param("columnId") Long columnId,@Param("fileId") Long fileId);

    void addBlog(@Param("columnId") Long columnId,@Param("fileId") Long fileId);

    void createColumn(@Param("userId") Long userId,@Param("columnName") String column_name,@Param("columnIntro") String column_intro);
}
